﻿using System.Collections.Generic;
using IDAL;
using Model;

//SQLServer数据库访问实现类
namespace SqlDalLibrary
{
    public class SQLDal : IUser
    {
        public void saveUser(User user)
        {
            DbManager.ExecuteSql(
                      "insert into [Database_1].[dbo].[User](uid,pwd,email,gender,nickname) values("
                          + user.Id + ",'"
                          + user.Password + "','"
                          + user.Email + "',"
                          + user.Sex + ",'"
                          + user.Name + "')");
        }

        public void modifyUser(User user) { }
        public void deleteUser(User user) { }
        public User getUser(int id) { return null; }
        public User getUser(string email) { return null; }
        public IList<User> getUser() { return null; }
    }
}
